<%@page import="org.omg.CORBA.PUBLIC_MEMBER"%>
<%@ page language="java" contentType="text/html; charset=utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<html>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<head>
    <title>教师录入成绩界面</title>
    <style type="text/css">
        table,thead,tbody,tfoot,th,td{border:1px dashed blue;}
    </style>
</head>
<body style="background:#8080C0">
  <div align="center" vertical-align="center">
<% 
Connection con;
Statement sql; 
ResultSet rs;
ResultSet tt;
try{  Class.forName("com.mysql.jdbc.Driver");
}
catch(Exception e){
   out.println("");
}
try{ String uri= "jdbc:mysql://127.0.0.1/liuhuan";
String user="root";
String password="";
con=DriverManager.getConnection(uri,user,password);
sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
                        ResultSet.CONCUR_READ_ONLY);
    String xh=request.getParameter("xh");
    String xm =request.getParameter("xm");
    String lj=request.getParameter("lj");
    String ls=request.getParameter("ls");
    String mg=request.getParameter("mg");
    String sjk=request.getParameter("sjk");
    String yy=request.getParameter("yy");
    String condition = "INSERT INTO "+"product"+" VALUES"+"("+ " '"+xm+"','"+xh+"','"+lj+"','"+ls+"','"+mg+"','"+sjk+"','"+yy+"' " +")";
   sql.executeUpdate(condition);
         con.close();
   }
   catch(SQLException e){ 
         out.print(e);
   }
%>
</body></HTML>